SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Alter Procedure [dbo].[spCapNhatNhanVien]
	@maNV int,
	@tenNV string(50),
	@cmnd string(9),
	@diaChi string(100),
	@sdt string(15),
	@ngaySinh datetime,
	@maLoaiNV int,
	@maNH int,
	@ngayLam datetime
As
Begin
	Update NhanVien
	Set
		TenNV = @tenNV,
		CMND = @cmnd,
		DiaChi = @diaChi,
		SDT = @sdt,
		NgaySinh = @ngaySinh,
		MaLoaiNV = @maLoaiNV,
		MaNH = @maNH,
		NgayLam = @ngayLam
	Where MaNV = @maNV
End